Customer Profile Report

Brought to you by YData

Dataset statistics

Number of variables	12
Number of observations	2969
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.5 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`avg_basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`avg_ticket` is highly overall correlated with `avg_unique_basket_size`	High correlation
`avg_unique_basket_size` is highly overall correlated with `avg_ticket` and 1 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`gross_revenue` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`qtde_invoices` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_items` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`qtde_products` is highly overall correlated with `avg_unique_basket_size` and 3 other fields	High correlation
`recency_days` is highly overall correlated with `qtde_invoices`	High correlation
`avg_ticket` is highly skewed (γ1 = 53.44422362)	Skewed
`frequency` is highly skewed (γ1 = 24.88049136)	Skewed
`qtde_returns` is highly skewed (γ1 = 51.79774426)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.67271661)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`qtde_returns` has 1481 (49.9%) zeros	Zeros

Reproduction

Analysis started	2025-07-07 03:02:43.491175
Analysis finished	2025-07-07 03:02:56.920072
Duration	13.43 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

customer_id
Real number (ℝ)

Unique

Distinct	2969
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.773

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.4
Q1	13799
median	15221
Q3	16768
95-th percentile	17964.6
Maximum	18287
Range	5940
Interquartile range (IQR)	2969

Descriptive statistics

Standard deviation	1718.9903
Coefficient of variation (CV)	0.11256734
Kurtosis	-1.2060947
Mean	15270.773
Median Absolute Deviation (MAD)	1488
Skewness	0.031607859
Sum	45338925
Variance	2954927.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12558	1	< 0.1%
17850	1	< 0.1%
13047	1	< 0.1%
12583	1	< 0.1%
13748	1	< 0.1%
15100	1	< 0.1%
15291	1	< 0.1%
14688	1	< 0.1%
17809	1	< 0.1%
16956	1	< 0.1%
Other values (2959)	2959	99.7%

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ)

High correlation

Distinct	2954
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2749.3217

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.77
Q1	570.96
median	1086.92
Q3	2308.06
95-th percentile	7219.68
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1737.1

Descriptive statistics

Standard deviation	10580.623
Coefficient of variation (CV)	3.8484486
Kurtosis	353.94472
Mean	2749.3217
Median Absolute Deviation (MAD)	672.16
Skewness	16.777556
Sum	8162736.2
Variance	1.1194959 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
533.33	2	0.1%
734.94	2	0.1%
178.96	2	0.1%
1078.96	2	0.1%
598.2	2	0.1%
1314.45	2	0.1%
379.65	2	0.1%
2053.02	2	0.1%
331	2	0.1%
889.93	2	0.1%
Other values (2944)	2949	99.3%

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ)

High correlation Zeros

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.287639

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.756779
Coefficient of variation (CV)	1.2095137
Kurtosis	2.7779627
Mean	64.287639
Median Absolute Deviation (MAD)	26
Skewness	1.7983795
Sum	190870
Variance	6046.1167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.9%
2	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2219	74.7%

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtde_invoices
Real number (ℝ)

High correlation

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7231391

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8565313
Coefficient of variation (CV)	1.5474954
Kurtosis	190.83445
Mean	5.7231391
Median Absolute Deviation (MAD)	2
Skewness	10.766805
Sum	16992
Variance	78.438147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	785	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Value	Count	Frequency (%)
1	190	6.4%
2	785	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtde_items
Real number (ℝ)

High correlation

Distinct	1671
Distinct (%)	56.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1608.8525

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	102.4
Q1	296
median	641
Q3	1401
95-th percentile	4407.4
Maximum	196844
Range	196843
Interquartile range (IQR)	1105

Descriptive statistics

Standard deviation	5887.578
Coefficient of variation (CV)	3.6594891
Kurtosis	465.99808
Mean	1608.8525
Median Absolute Deviation (MAD)	422
Skewness	17.858591
Sum	4776683
Variance	34663575
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	9	0.3%
88	9	0.3%
84	8	0.3%
260	8	0.3%
288	8	0.3%
272	8	0.3%
246	8	0.3%
114	7	0.2%
134	7	0.2%
Other values (1661)	2886	97.2%

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%

qtde_products
Real number (ℝ)

High correlation

Distinct	468
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.72415

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.89641
Coefficient of variation (CV)	2.1992119
Kurtosis	354.86113
Mean	122.72415
Median Absolute Deviation (MAD)	44
Skewness	15.707635
Sum	364368
Variance	72844.071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	43	1.4%
20	37	1.2%
29	35	1.2%
35	35	1.2%
19	34	1.1%
15	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
25	30	1.0%
Other values (458)	2629	88.5%

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ)

High correlation Skewed

Distinct	2966
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.897762

Minimum	2.1505882
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.9166611
Q1	13.119333
median	17.956587
Q3	24.988286
95-th percentile	90.497
Maximum	56157.5
Range	56155.349
Interquartile range (IQR)	11.868952

Descriptive statistics

Standard deviation	1036.9344
Coefficient of variation (CV)	19.98033
Kurtosis	2890.7071
Mean	51.897762
Median Absolute Deviation (MAD)	5.984842
Skewness	53.444224
Sum	154084.45
Variance	1075233
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
15	2	0.1%
4.162	2	0.1%
33.86607143	1	< 0.1%
292	1	< 0.1%
45.32647059	1	< 0.1%
6.932857143	1	< 0.1%
5.66585034	1	< 0.1%
18.15222222	1	< 0.1%
80.13043478	1	< 0.1%
Other values (2956)	2956	99.6%

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ)

High correlation

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.348511

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.923077
median	48.285714
Q3	85.333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.410256

Descriptive statistics

Standard deviation	63.544929
Coefficient of variation (CV)	0.94352388
Kurtosis	4.8871091
Mean	67.348511
Median Absolute Deviation (MAD)	26.285714
Skewness	2.0627709
Sum	199957.73
Variance	4037.958
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
21	17	0.6%
46	17	0.6%
11	17	0.6%
42	16	0.5%
Other values (1248)	2777	93.5%

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

High correlation Skewed

Distinct	1225
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1137973

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0088941642
Q1	0.016339869
median	0.025889968
Q3	0.049450549
95-th percentile	1
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.03311068

Descriptive statistics

Standard deviation	0.40815625
Coefficient of variation (CV)	3.5866953
Kurtosis	989.36508
Mean	0.1137973
Median Absolute Deviation (MAD)	0.012191338
Skewness	24.880491
Sum	337.8642
Variance	0.16659153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.5%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.02941176471	14	0.5%
0.03448275862	14	0.5%
0.02564102564	13	0.4%
0.01923076923	13	0.4%
Other values (1215)	2636	88.8%

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtde_returns
Real number (ℝ)

Skewed Zeros

Distinct	214
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.156955

Minimum	0
Maximum	80995
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100.6
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1512.4961
Coefficient of variation (CV)	24.333498
Kurtosis	2765.5286
Mean	62.156955
Median Absolute Deviation (MAD)	1
Skewness	51.797744
Sum	184544
Variance	2287644.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
8	43	1.4%
7	43	1.4%
Other values (204)	706	23.8%

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ)

High correlation Skewed

Distinct	1979
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.81376

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.25
median	172.33333
Q3	281.69231
95-th percentile	600
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.44231

Descriptive statistics

Standard deviation	791.55519
Coefficient of variation (CV)	3.1685812
Kurtosis	2255.5382
Mean	249.81376
Median Absolute Deviation (MAD)	83.083333
Skewness	44.672717
Sum	741697.07
Variance	626559.62
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
73	9	0.3%
86	9	0.3%
82	9	0.3%
136	8	0.3%
75	8	0.3%
88	8	0.3%
60	8	0.3%
130	7	0.2%
Other values (1969)	2882	97.1%

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ)

High correlation

Distinct	906
Distinct (%)	30.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.484591

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.6666667
median	13.6
Q3	22.142857
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.47619

Descriptive statistics

Standard deviation	15.460307
Coefficient of variation (CV)	0.8842247
Kurtosis	29.317441
Mean	17.484591
Median Absolute Deviation (MAD)	6.6
Skewness	3.4358615
Sum	51911.752
Variance	239.02111
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	42	1.4%
9	41	1.4%
8	39	1.3%
16	39	1.3%
14	38	1.3%
17	38	1.3%
7	36	1.2%
11	36	1.2%
5	36	1.2%
15	35	1.2%
Other values (896)	2589	87.2%

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

	avg_basket_size	avg_recency_days	avg_ticket	avg_unique_basket_size	customer_id	frequency	gross_revenue	qtde_invoices	qtde_items	qtde_products	qtde_returns	recency_days
avg_basket_size	1.000	-0.077	0.188	0.402	-0.123	0.027	0.574	0.100	0.729	0.383	0.210	-0.098
avg_recency_days	-0.077	1.000	-0.122	0.130	0.019	-0.881	-0.247	-0.259	-0.227	-0.166	-0.396	0.108
avg_ticket	0.188	-0.122	1.000	-0.618	-0.131	0.090	0.246	0.059	0.167	-0.377	0.190	0.048
avg_unique_basket_size	0.402	0.130	-0.618	1.000	-0.016	-0.121	0.104	-0.181	0.147	0.516	-0.054	0.015
customer_id	-0.123	0.019	-0.131	-0.016	1.000	-0.002	-0.076	0.026	-0.070	0.013	-0.063	0.001
frequency	0.027	-0.881	0.090	-0.121	-0.002	1.000	0.090	0.079	0.080	0.036	0.234	0.018
gross_revenue	0.574	-0.247	0.246	0.104	-0.076	0.090	1.000	0.770	0.925	0.744	0.372	-0.415
qtde_invoices	0.100	-0.259	0.059	-0.181	0.026	0.079	0.770	1.000	0.716	0.690	0.294	-0.502
qtde_items	0.729	-0.227	0.167	0.147	-0.070	0.080	0.925	0.716	1.000	0.730	0.344	-0.408
qtde_products	0.383	-0.166	-0.377	0.516	0.013	0.036	0.744	0.690	0.730	1.000	0.242	-0.435
qtde_returns	0.210	-0.396	0.190	-0.054	-0.063	0.234	0.372	0.294	0.344	0.242	1.000	-0.120
recency_days	-0.098	0.108	0.048	0.015	0.001	0.018	-0.415	-0.502	-0.408	-0.435	-0.120	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	35.500000	17.000000	40.0	50.970588	0.617647
1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	27.250000	0.028302	35.0	154.444444	11.666667
2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	23.187500	0.040323	50.0	335.200000	7.600000
3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	4.800000
4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	8.600000	0.073171	22.0	26.666667	0.333333
5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	23.200000	0.040115	29.0	150.142857	4.357143
6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	18.300000	0.057221	399.0	172.428571	7.047619
7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	35.700000	0.033520	41.0	171.416667	3.833333
8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.144444	0.243316	474.0	419.714286	6.230769
9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	47.666667	0.024390	0.0	87.571429	4.857143

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
4269	17727	1060.25	15.0	1.0	645.0	66.0	16.064394	6.0	1.000000	6.0	645.000000	66.000000
4277	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.153846	0.0	101.500000	15.000000
4278	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000
4281	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	66.500000
4286	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.000000
4290	12479	473.20	11.0	1.0	382.0	30.0	15.773333	4.0	1.000000	34.0	382.000000	30.000000
4305	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	0.750000	50.0	169.333333	4.666667
4309	13521	1092.39	1.0	3.0	733.0	435.0	2.511241	4.5	0.300000	0.0	244.333333	104.000000
4314	15060	301.84	8.0	4.0	262.0	120.0	2.515333	1.0	2.000000	0.0	65.500000	20.000000
4319	12558	269.96	7.0	1.0	196.0	11.0	24.541818	6.0	1.000000	196.0	196.000000	11.000000

Overview

Interactions

Correlations

Missing values

Sample

Overview

Variables

Interactions

Correlations

Missing values

Sample